<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title>Docs For Class Database</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
			<div class="page-body">			
<h2 class="class-name">Class Database</h2>

<a name="sec-description"></a>
<div class="info-box">
	<div class="info-box-title">Description</div>
	<div class="nav-bar">
					<span class="disabled">Description</span> |
															<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
						
					</div>
	<div class="info-box-body">
        		<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Die Klasse, um die Datenbankfunktionen  zu verwalten bzw. um auf die Datenbank zuzugreifen.</p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
			</ul>
		<p class="notes">
			Located in <a class="field" href="_Database---Database.php.html">/Database/Database.php</a> (line <span class="field">8</span>)
		</p>
		
				
		<pre></pre>
	
			</div>
</div>




	<a name="sec-method-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Method Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
												<span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
		</div>
		<div class="info-box-body">			
			<div class="method-summary">
																																																																																																												
												<div class="method-definition">
											<span class="method-result">Database</span>
										<a href="#__construct" title="details" class="method-name">__construct</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#__destruct" title="details" class="method-name">__destruct</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#ChangeDatabase" title="details" class="method-name">ChangeDatabase</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$database</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Connect" title="details" class="method-name">Connect</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#CreateTable" title="details" class="method-name">CreateTable</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columnArray</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$valueArray</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Delete" title="details" class="method-name">Delete</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$where</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Disconnect" title="details" class="method-name">Disconnect</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#ExecSQL" title="details" class="method-name">ExecSQL</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$sql_string</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#GenerateTables" title="details" class="method-name">GenerateTables</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$series_table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$prefix</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$league_id</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$steam</span> = <span class="var-default">false</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Insert" title="details" class="method-name">Insert</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columnArray</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$valueArray</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Select" title="details" class="method-name">Select</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$orderby</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$order</span> = <span class="var-default">'ASC'</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#SelectColumns" title="details" class="method-name">SelectColumns</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columns</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$orderby</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$order</span> = <span class="var-default">'ASC'</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#Update" title="details" class="method-name">Update</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$column</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$value</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">&quot;&quot;</span>])
									</div>
								</div>
		</div>
	</div>		

	
	<a name="sec-methods"></a>
	<div class="info-box">
		<div class="info-box-title">Methods</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
																<a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
						
		</div>
		<div class="info-box-body">
			<A NAME='method_detail'></A>

<a name="method__construct" id="__construct"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">Constructor __construct</span> (line <span class="line-number">46</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Daten werden gesetzt.</p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">Database</span>
		<span class="method-name">
			__construct
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method__destruct" id="__destruct"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Destructor __destruct</span> (line <span class="line-number">56</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Eventuell offene Verbindung schließen.</p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			__destruct
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodChangeDatabase" id="ChangeDatabase"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">ChangeDatabase</span> (line <span class="line-number">16</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			ChangeDatabase
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$database</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$database</span>			</li>
				</ul>
		
			
	</div>
<a name="methodConnect" id="Connect"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Connect</span> (line <span class="line-number">66</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Connect
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodCreateTable" id="CreateTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">CreateTable</span> (line <span class="line-number">344</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Tabelle in der Datenbank erstellen.</p>
<p class="description"><p>Values: 'i' = integer, 's' = string, 'auto' = auto_increment  Wichtig: Die beiden übergebenen Arrays müssen gleichgroß sein!          'auto' darf nur einmal vergeben werden!</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			CreateTable
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columnArray</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$valueArray</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$columnArray</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$valueArray</span>			</li>
				</ul>
		
			
	</div>
<a name="methodDelete" id="Delete"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Delete</span> (line <span class="line-number">504</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Delete
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$where</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
				</ul>
		
			
	</div>
<a name="methodDisconnect" id="Disconnect"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">Disconnect</span> (line <span class="line-number">79</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Disconnect
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodExecSQL" id="ExecSQL"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">ExecSQL</span> (line <span class="line-number">198</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			ExecSQL
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$sql_string</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$sql_string</span>			</li>
				</ul>
		
			
	</div>
<a name="methodGenerateTables" id="GenerateTables"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">GenerateTables</span> (line <span class="line-number">426</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Tabellen für eine Serie erstellen.</p>
<p class="description"><p>//TODO// -&gt; Dynamischer</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			GenerateTables
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$series_table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$prefix</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$league_id</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$steam</span> = <span class="var-default">false</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$series_table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$prefix</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$league_id</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$steam</span>			</li>
				</ul>
		
			
	</div>
<a name="methodInsert" id="Insert"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Insert</span> (line <span class="line-number">237</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Durch INSERT Statement Objekt in die Datenbank schreiben.</p>
<p class="description"><p>Wichtig: Die beiden übergebenen Arrays müssen gleichgroß sein!</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Insert
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columnArray</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$valueArray</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$columnArray</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$valueArray</span>			</li>
				</ul>
		
			
	</div>
<a name="methodSelect" id="Select"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">Select</span> (line <span class="line-number">97</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">SELECT Statement mit optionalem WHERE Statement.</p>
<p class="description"><p>Bsp. SELECT * FROM [Tabelle] WHERE [Statement]</p><p>Gibt Objekt bzw. Objekte zurück.</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Select
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$orderby</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$order</span> = <span class="var-default">'ASC'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$orderby</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$order</span>			</li>
				</ul>
		
			
	</div>
<a name="methodSelectColumns" id="SelectColumns"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">SelectColumns</span> (line <span class="line-number">151</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">SELECT Statement mit optionalem WHERE Statement.</p>
<p class="description"><p>Bsp. SELECT * FROM [Tabelle] WHERE [Statement]</p><p>Gibt Objekt bzw. Objekte zurück.</p><p>Unterschied zu normalem Select -&gt; Auswählen von gewissen Spalten..</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			SelectColumns
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$columns</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$orderby</span> = <span class="var-default">''</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$order</span> = <span class="var-default">'ASC'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$columns</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$orderby</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$order</span>			</li>
				</ul>
		
			
	</div>
<a name="methodUpdate" id="Update"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">Update</span> (line <span class="line-number">317</span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Durch UPDATE Statement Objekt in der Datenbank aktualisieren.</p>
<p class="description"><p>Optional: WHERE Statement, bspw. &quot;WHERE Points = 100&quot;</p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Timo</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			Update
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$table</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$column</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$value</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$where</span> = <span class="var-default">&quot;&quot;</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$column</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$value</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$where</span>			</li>
				</ul>
		
			
	</div>
						
		</div>
	</div>


	<p class="notes" id="credit">
		Documentation generated on Wed, 07 Mar 2012 19:25:00 +0100 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.3</a>
	</p>
	</div></body>
</html>